SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




alter        VIEW dbo.v_tt_traderprice
AS
SELECT tp.*, u.unitname, t.name as tradername,m.name as moneyname,
  p.name p_name,p.code p_code,p.spec p_spec
FROM dbo.tt_traderprice tp 
LEFT OUTER JOIN dbo.td_unitprice u ON tp.unitid = u.unitid
left join td_money m on tp.moneyid=m.moneyid
left join td_trader t on tp.traderid = t.traderid
left join td_product p on tp.productid=p.p_id







GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

